YData Profiling Report

Dataset statistics

Number of variables	15
Number of observations	18835
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	2205
Duplicate rows (%)	11.7%
Total size in memory	2.8 MiB
Average record size in memory	157.1 B

Variable types

Text	1
Numeric	12
Categorical	2

Alerts

Dataset has 2205 (11.7%) duplicate rows	Duplicates
`acousticness` is highly overall correlated with `energy`	High correlation
`energy` is highly overall correlated with `acousticness` and 1 other fields	High correlation
`loudness` is highly overall correlated with `energy`	High correlation
`time_signature` is highly imbalanced (83.6%)	Imbalance
`song_popularity` has 272 (1.4%) zeros	Zeros
`instrumentalness` has 7150 (38.0%) zeros	Zeros
`key` has 2182 (11.6%) zeros	Zeros

Reproduction

Analysis started	2024-12-15 16:26:39.736957
Analysis finished	2024-12-15 16:27:24.159109
Duration	44.42 seconds
Software version	ydata-profiling vv4.12.1
Download configuration	config.json

song_name
Text

Distinct	13070
Distinct (%)	69.4%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Length

Max length	143
Median length	92
Mean length	16.617308
Min length	1

Characters and Unicode

Total characters	312987
Distinct characters	308
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10174 ?
Unique (%)	54.0%

Sample

1st row	Boulevard of Broken Dreams
2nd row	In The End
3rd row	Seven Nation Army
4th row	By The Way
5th row	How You Remind Me

Value	Count	Frequency (%)
	2458	4.1%
the	1614	2.7%
feat	1496	2.5%
you	1051	1.8%
me	909	1.5%
i	735	1.2%
love	650	1.1%
my	542	0.9%
a	532	0.9%
to	514	0.9%
Other values (9918)	49458	82.5%

Most occurring characters

Value	Count	Frequency (%)
	41124	13.1%
e	29073	9.3%
a	18940	6.1%
o	18724	6.0%
i	16006	5.1%
t	14461	4.6%
n	14373	4.6%
r	12900	4.1%
s	9650	3.1%
l	9621	3.1%
Other values (298)	128115	40.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	312987	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	41124	13.1%
e	29073	9.3%
a	18940	6.1%
o	18724	6.0%
i	16006	5.1%
t	14461	4.6%
n	14373	4.6%
r	12900	4.1%
s	9650	3.1%
l	9621	3.1%
Other values (298)	128115	40.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	312987	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	41124	13.1%
e	29073	9.3%
a	18940	6.1%
o	18724	6.0%
i	16006	5.1%
t	14461	4.6%
n	14373	4.6%
r	12900	4.1%
s	9650	3.1%
l	9621	3.1%
Other values (298)	128115	40.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	312987	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	41124	13.1%
e	29073	9.3%
a	18940	6.1%
o	18724	6.0%
i	16006	5.1%
t	14461	4.6%
n	14373	4.6%
r	12900	4.1%
s	9650	3.1%
l	9621	3.1%
Other values (298)	128115	40.9%

song_popularity
Real number (ℝ)

Zeros

Distinct	101
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.991877

Minimum	0
Maximum	100
Zeros	272
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	36.9 KiB

Quantile statistics

Minimum	0
5-th percentile	8
Q1	40
median	56
Q3	69
95-th percentile	85
Maximum	100
Range	100
Interquartile range (IQR)	29

Descriptive statistics

Standard deviation	21.905654
Coefficient of variation (CV)	0.41337759
Kurtosis	-0.16910371
Mean	52.991877
Median Absolute Deviation (MAD)	14
Skewness	-0.50148747
Sum	998102
Variance	479.85769
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
58	404	2.1%
52	389	2.1%
55	388	2.1%
60	383	2.0%
63	378	2.0%
62	370	2.0%
65	364	1.9%
64	364	1.9%
61	360	1.9%
69	359	1.9%
Other values (91)	15076	80.0%

Value	Count	Frequency (%)
0	272	1.4%
1	111	0.6%
2	103	0.5%
3	72	0.4%
4	91	0.5%
5	83	0.4%
6	70	0.4%
7	78	0.4%
8	85	0.5%
9	61	0.3%

Value	Count	Frequency (%)
100	12	0.1%
99	16	0.1%
98	47	0.2%
97	36	0.2%
96	53	0.3%
95	61	0.3%
94	85	0.5%
93	32	0.2%
92	62	0.3%
91	95	0.5%

song_duration_ms
Real number (ℝ)

Distinct	11260
Distinct (%)	59.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	410.07677

Minimum	-32768
Maximum	32765
Zeros	0
Zeros (%)	0.0%
Negative	9240
Negative (%)	49.1%
Memory size	36.9 KiB

Quantile statistics

Minimum	-32768
5-th percentile	-29507
Q1	-15599.5
median	613
Q3	16436.5
95-th percentile	29418
Maximum	32765
Range	-3
Interquartile range (IQR)	32036

Descriptive statistics

Standard deviation	18738.093
Coefficient of variation (CV)	45.694109
Kurtosis	-1.1663965
Mean	410.07677
Median Absolute Deviation (MAD)	15958
Skewness	-0.040086578
Sum	7723796
Variance	3.5111613 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-31608	25	0.1%
-16608	21	0.1%
-17204	20	0.1%
-7608	20	0.1%
15892	20	0.1%
13759	18	0.1%
20928	18	0.1%
-4436	17	0.1%
-1608	17	0.1%
-3126	16	0.1%
Other values (11250)	18643	99.0%

Value	Count	Frequency (%)
-32768	2	< 0.1%
-32758	1	< 0.1%
-32755	1	< 0.1%
-32751	1	< 0.1%
-32744	2	< 0.1%
-32743	1	< 0.1%
-32740	1	< 0.1%
-32739	1	< 0.1%
-32738	4	< 0.1%
-32732	12	0.1%

Value	Count	Frequency (%)
32765	1	< 0.1%
32762	2	< 0.1%
32752	9	< 0.1%
32747	3	< 0.1%
32738	2	< 0.1%
32733	1	< 0.1%
32728	1	< 0.1%
32712	7	< 0.1%
32698	1	< 0.1%
32696	3	< 0.1%

acousticness
Real number (ℝ)

High correlation

Distinct	3209
Distinct (%)	17.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.25853902

Minimum	1.02 × 10^-6
Maximum	0.996
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	147.3 KiB

Quantile statistics

Minimum	1.02 × 10^-6
5-th percentile	0.000633
Q1	0.0241
median	0.132
Q3	0.424
95-th percentile	0.882
Maximum	0.996
Range	0.99599898
Interquartile range (IQR)	0.3999

Descriptive statistics

Standard deviation	0.28871891
Coefficient of variation (CV)	1.1167324
Kurtosis	-0.096275738
Mean	0.25853902
Median Absolute Deviation (MAD)	0.126
Skewness	1.0711642
Sum	4869.5824
Variance	0.083358608
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.13	45	0.2%
0.135	44	0.2%
0.153	43	0.2%
0.102	41	0.2%
0.107	40	0.2%
0.0215	39	0.2%
0.161	38	0.2%
0.141	38	0.2%
0.128	37	0.2%
0.173	36	0.2%
Other values (3199)	18434	97.9%

Value	Count	Frequency (%)
1.02 × 10^-6	1	< 0.1%
1.36 × 10^-6	1	< 0.1%
1.37 × 10^-6	1	< 0.1%
1.4 × 10^-6	1	< 0.1%
1.8 × 10^-6	1	< 0.1%
1.95 × 10^-6	1	< 0.1%
2.01 × 10^-6	1	< 0.1%
2.18 × 10^-6	1	< 0.1%
2.42 × 10^-6	1	< 0.1%
2.58 × 10^-6	1	< 0.1%

Value	Count	Frequency (%)
0.996	15	0.1%
0.995	26	0.1%
0.994	20	0.1%
0.993	22	0.1%
0.992	14	0.1%
0.991	17	0.1%
0.99	13	0.1%
0.989	9	< 0.1%
0.988	10	0.1%
0.987	7	< 0.1%

danceability
Real number (ℝ)

Distinct	849
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.63334807

Minimum	0
Maximum	0.987
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	147.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0.354
Q1	0.533
median	0.645
Q3	0.748
95-th percentile	0.876
Maximum	0.987
Range	0.987
Interquartile range (IQR)	0.215

Descriptive statistics

Standard deviation	0.15672271
Coefficient of variation (CV)	0.24745114
Kurtosis	-0.074796762
Mean	0.63334807
Median Absolute Deviation (MAD)	0.107
Skewness	-0.39171912
Sum	11929.111
Variance	0.024562006
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.687	73	0.4%
0.694	73	0.4%
0.6	65	0.3%
0.657	65	0.3%
0.757	64	0.3%
0.611	64	0.3%
0.699	62	0.3%
0.646	62	0.3%
0.659	61	0.3%
0.71	59	0.3%
Other values (839)	18187	96.6%

Value	Count	Frequency (%)
0	2	< 0.1%
0.0594	1	< 0.1%
0.0617	1	< 0.1%
0.0625	1	< 0.1%
0.066	1	< 0.1%
0.0674	1	< 0.1%
0.0684	1	< 0.1%
0.0722	1	< 0.1%
0.081	1	< 0.1%
0.0812	1	< 0.1%

Value	Count	Frequency (%)
0.987	1	< 0.1%
0.981	1	< 0.1%
0.98	1	< 0.1%
0.978	3	< 0.1%
0.975	3	< 0.1%
0.972	1	< 0.1%
0.971	1	< 0.1%
0.97	1	< 0.1%
0.969	1	< 0.1%
0.968	2	< 0.1%

energy
Real number (ℝ)

High correlation

Distinct	1132
Distinct (%)	6.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.64499476

Minimum	0.00107
Maximum	0.999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	147.3 KiB

Quantile statistics

Minimum	0.00107
5-th percentile	0.237
Q1	0.51
median	0.674
Q3	0.815
95-th percentile	0.941
Maximum	0.999
Range	0.99793
Interquartile range (IQR)	0.305

Descriptive statistics

Standard deviation	0.21410076
Coefficient of variation (CV)	0.33194186
Kurtosis	-0.13787455
Mean	0.64499476
Median Absolute Deviation (MAD)	0.151
Skewness	-0.62073751
Sum	12148.476
Variance	0.045839134
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.704	62	0.3%
0.63	58	0.3%
0.717	57	0.3%
0.73	53	0.3%
0.786	52	0.3%
0.805	52	0.3%
0.849	51	0.3%
0.694	51	0.3%
0.783	50	0.3%
0.785	49	0.3%
Other values (1122)	18300	97.2%

Value	Count	Frequency (%)
0.00107	2	< 0.1%
0.00163	1	< 0.1%
0.00205	1	< 0.1%
0.00212	1	< 0.1%
0.00264	1	< 0.1%
0.00266	1	< 0.1%
0.00289	1	< 0.1%
0.00305	1	< 0.1%
0.00344	1	< 0.1%
0.00362	1	< 0.1%

Value	Count	Frequency (%)
0.999	1	< 0.1%
0.997	3	< 0.1%
0.996	6	< 0.1%
0.995	8	< 0.1%
0.994	10	0.1%
0.993	7	< 0.1%
0.992	8	< 0.1%
0.991	13	0.1%
0.99	19	0.1%
0.989	14	0.1%

instrumentalness
Real number (ℝ)

Zeros

Distinct	3925
Distinct (%)	20.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.078008039

Minimum	0
Maximum	0.997
Zeros	7150
Zeros (%)	38.0%
Negative	0
Negative (%)	0.0%
Memory size	147.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1.14 × 10^-5
Q3	0.00257
95-th percentile	0.782
Maximum	0.997
Range	0.997
Interquartile range (IQR)	0.00257

Descriptive statistics

Standard deviation	0.22159061
Coefficient of variation (CV)	2.8406125
Kurtosis	7.5636644
Mean	0.078008039
Median Absolute Deviation (MAD)	1.14 × 10^-5
Skewness	2.9851764
Sum	1469.2814
Variance	0.049102398
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7150	38.0%
3.33 × 10^-6	37	0.2%
0.00107	21	0.1%
0.00114	20	0.1%
0.000512	18	0.1%
0.00103	17	0.1%
1.16 × 10^-6	17	0.1%
4.91 × 10^-6	16	0.1%
1.07 × 10^-5	16	0.1%
1.03 × 10^-5	16	0.1%
Other values (3915)	11507	61.1%

Value	Count	Frequency (%)
0	7150	38.0%
1 × 10^-6	2	< 0.1%
1.01 × 10^-6	6	< 0.1%
1.02 × 10^-6	8	< 0.1%
1.03 × 10^-6	8	< 0.1%
1.04 × 10^-6	12	0.1%
1.05 × 10^-6	7	< 0.1%
1.06 × 10^-6	5	< 0.1%
1.07 × 10^-6	9	< 0.1%
1.08 × 10^-6	5	< 0.1%

Value	Count	Frequency (%)
0.997	1	< 0.1%
0.989	1	< 0.1%
0.982	1	< 0.1%
0.979	1	< 0.1%
0.978	1	< 0.1%
0.977	1	< 0.1%
0.975	1	< 0.1%
0.974	1	< 0.1%
0.973	3	< 0.1%
0.972	2	< 0.1%

key
Real number (ℝ)

Zeros

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.2891956

Minimum	0
Maximum	11
Zeros	2182
Zeros (%)	11.6%
Negative	0
Negative (%)	0.0%
Memory size	36.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	8
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.6145946
Coefficient of variation (CV)	0.68339212
Kurtosis	-1.3114659
Mean	5.2891956
Median Absolute Deviation (MAD)	3
Skewness	-0.0025200197
Sum	99622
Variance	13.065294
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	2182	11.6%
1	2164	11.5%
7	2032	10.8%
2	1715	9.1%
9	1698	9.0%
11	1600	8.5%
5	1574	8.4%
6	1351	7.2%
8	1349	7.2%
10	1331	7.1%
Other values (2)	1839	9.8%

Value	Count	Frequency (%)
0	2182	11.6%
1	2164	11.5%
2	1715	9.1%
3	512	2.7%
4	1327	7.0%
5	1574	8.4%
6	1351	7.2%
7	2032	10.8%
8	1349	7.2%
9	1698	9.0%

Value	Count	Frequency (%)
11	1600	8.5%
10	1331	7.1%
9	1698	9.0%
8	1349	7.2%
7	2032	10.8%
6	1351	7.2%
5	1574	8.4%
4	1327	7.0%
3	512	2.7%
2	1715	9.1%

liveness
Real number (ℝ)

Distinct	1425
Distinct (%)	7.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.17965031

Minimum	0.0109
Maximum	0.986
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	147.3 KiB

Quantile statistics

Minimum	0.0109
5-th percentile	0.0575
Q1	0.0929
median	0.122
Q3	0.221
95-th percentile	0.466
Maximum	0.986
Range	0.9751
Interquartile range (IQR)	0.1281

Descriptive statistics

Standard deviation	0.14398417
Coefficient of variation (CV)	0.80146908
Kurtosis	5.789919
Mean	0.17965031
Median Absolute Deviation (MAD)	0.042
Skewness	2.2154227
Sum	3383.7135
Variance	0.02073144
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.108	219	1.2%
0.111	206	1.1%
0.104	197	1.0%
0.106	195	1.0%
0.109	190	1.0%
0.11	188	1.0%
0.102	187	1.0%
0.112	187	1.0%
0.107	186	1.0%
0.101	178	0.9%
Other values (1415)	16902	89.7%

Value	Count	Frequency (%)
0.0109	1	< 0.1%
0.0119	1	< 0.1%
0.0148	1	< 0.1%
0.0157	1	< 0.1%
0.0186	1	< 0.1%
0.0193	1	< 0.1%
0.0196	3	< 0.1%
0.0206	1	< 0.1%
0.0215	1	< 0.1%
0.0219	1	< 0.1%

Value	Count	Frequency (%)
0.986	1	< 0.1%
0.984	1	< 0.1%
0.983	1	< 0.1%
0.981	2	< 0.1%
0.979	1	< 0.1%
0.978	2	< 0.1%
0.977	1	< 0.1%
0.975	1	< 0.1%
0.974	1	< 0.1%
0.967	1	< 0.1%

loudness
Real number (ℝ)

High correlation

Distinct	8416
Distinct (%)	44.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-7.4474347

Minimum	-38.768
Maximum	1.585
Zeros	0
Zeros (%)	0.0%
Negative	18828
Negative (%)	> 99.9%
Memory size	147.3 KiB

Quantile statistics

Minimum	-38.768
5-th percentile	-14.295
Q1	-9.044
median	-6.555
Q3	-4.908
95-th percentile	-3.149
Maximum	1.585
Range	40.353
Interquartile range (IQR)	4.136

Descriptive statistics

Standard deviation	3.8278312
Coefficient of variation (CV)	-0.51397983
Kurtosis	6.5224796
Mean	-7.4474347
Median Absolute Deviation (MAD)	1.923
Skewness	-1.9295106
Sum	-140272.43
Variance	14.652292
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-4.589	24	0.1%
-4.206	20	0.1%
-9.127	19	0.1%
-6.35	18	0.1%
-5.144	18	0.1%
-6.439	18	0.1%
-8.304	17	0.1%
-5.991	17	0.1%
-5.593	17	0.1%
-5.351	17	0.1%
Other values (8406)	18650	99.0%

Value	Count	Frequency (%)
-38.768	1	< 0.1%
-36.729	1	< 0.1%
-36.281	1	< 0.1%
-35.449	1	< 0.1%
-35.389	2	< 0.1%
-34.255	1	< 0.1%
-33.929	1	< 0.1%
-33.859	1	< 0.1%
-33.493	1	< 0.1%
-33.246	1	< 0.1%

Value	Count	Frequency (%)
1.585	1	< 0.1%
1.342	1	< 0.1%
0.878	1	< 0.1%
0.525	1	< 0.1%
0.198	1	< 0.1%
0.119	1	< 0.1%
0.052	1	< 0.1%
-0.257	1	< 0.1%
-0.398	1	< 0.1%
-0.578	1	< 0.1%

audio_mode
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

1	11831
0	7004

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	18835
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	11831	62.8%
0	7004	37.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	11831	62.8%
0	7004	37.2%

Most occurring characters

Value	Count	Frequency (%)
1	11831	62.8%
0	7004	37.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	18835	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	11831	62.8%
0	7004	37.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	18835	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	11831	62.8%
0	7004	37.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	18835	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	11831	62.8%
0	7004	37.2%

speechiness
Real number (ℝ)

Distinct	1224
Distinct (%)	6.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.10209912

Minimum	0
Maximum	0.941
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	147.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0288
Q1	0.0378
median	0.0555
Q3	0.119
95-th percentile	0.334
Maximum	0.941
Range	0.941
Interquartile range (IQR)	0.0812

Descriptive statistics

Standard deviation	0.10437848
Coefficient of variation (CV)	1.0223249
Kurtosis	6.5049769
Mean	0.10209912
Median Absolute Deviation (MAD)	0.0227
Skewness	2.271018
Sum	1923.037
Variance	0.010894867
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0337	66	0.4%
0.032	61	0.3%
0.031	61	0.3%
0.0362	60	0.3%
0.038	59	0.3%
0.0318	58	0.3%
0.0329	58	0.3%
0.0439	56	0.3%
0.0457	55	0.3%
0.0333	55	0.3%
Other values (1214)	18246	96.9%

Value	Count	Frequency (%)
0	2	< 0.1%
0.0224	1	< 0.1%
0.0228	4	< 0.1%
0.0229	1	< 0.1%
0.0231	3	< 0.1%
0.0233	2	< 0.1%
0.0234	2	< 0.1%
0.0235	2	< 0.1%
0.0236	4	< 0.1%
0.0238	2	< 0.1%

Value	Count	Frequency (%)
0.941	1	< 0.1%
0.94	1	< 0.1%
0.936	1	< 0.1%
0.915	1	< 0.1%
0.906	1	< 0.1%
0.894	1	< 0.1%
0.891	2	< 0.1%
0.89	1	< 0.1%
0.869	2	< 0.1%
0.831	2	< 0.1%

tempo
Real number (ℝ)

Distinct	12112
Distinct (%)	64.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	121.07315

Minimum	0
Maximum	242.318
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	147.3 KiB

Quantile statistics

Minimum	0
5-th percentile	79.4165
Q1	98.368
median	120.013
Q3	139.931
95-th percentile	174.1473
Maximum	242.318
Range	242.318
Interquartile range (IQR)	41.563

Descriptive statistics

Standard deviation	28.714456
Coefficient of variation (CV)	0.23716617
Kurtosis	-0.21751669
Mean	121.07315
Median Absolute Deviation (MAD)	20.049
Skewness	0.44285458
Sum	2280412.9
Variance	824.51997
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
125.978	20	0.1%
95.948	19	0.1%
120.013	18	0.1%
97.064	18	0.1%
123.07	17	0.1%
147.055	17	0.1%
89.931	16	0.1%
128.038	16	0.1%
104.053	16	0.1%
118.159	16	0.1%
Other values (12102)	18662	99.1%

Value	Count	Frequency (%)
0	2	< 0.1%
46.591	1	< 0.1%
47.953	1	< 0.1%
51.607	1	< 0.1%
52.181	1	< 0.1%
54.213	1	< 0.1%
56.983	1	< 0.1%
56.985	1	< 0.1%
57	1	< 0.1%
57.107	1	< 0.1%

Value	Count	Frequency (%)
242.318	1	< 0.1%
216.115	1	< 0.1%
214.686	1	< 0.1%
213.99	1	< 0.1%
213.226	1	< 0.1%
212.137	1	< 0.1%
212.058	1	< 0.1%
211.644	1	< 0.1%
211.357	1	< 0.1%
210.75	1	< 0.1%

time_signature
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

4	17754
3	772
5	233
1	73
0	3

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	18835
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	4
4th row	4
5th row	4

Common Values

Value	Count	Frequency (%)
4	17754	94.3%
3	772	4.1%
5	233	1.2%
1	73	0.4%
0	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4	17754	94.3%
3	772	4.1%
5	233	1.2%
1	73	0.4%
0	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
4	17754	94.3%
3	772	4.1%
5	233	1.2%
1	73	0.4%
0	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	18835	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	17754	94.3%
3	772	4.1%
5	233	1.2%
1	73	0.4%
0	3	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	18835	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	17754	94.3%
3	772	4.1%
5	233	1.2%
1	73	0.4%
0	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	18835	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	17754	94.3%
3	772	4.1%
5	233	1.2%
1	73	0.4%
0	3	< 0.1%

audio_valence
Real number (ℝ)

Distinct	1246
Distinct (%)	6.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.52796688

Minimum	0
Maximum	0.984
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	147.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0.132
Q1	0.335
median	0.527
Q3	0.725
95-th percentile	0.924
Maximum	0.984
Range	0.984
Interquartile range (IQR)	0.39

Descriptive statistics

Standard deviation	0.24463169
Coefficient of variation (CV)	0.46334666
Kurtosis	-0.97767048
Mean	0.52796688
Median Absolute Deviation (MAD)	0.195
Skewness	-0.016423217
Sum	9944.2561
Variance	0.059844663
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.961	71	0.4%
0.964	61	0.3%
0.376	53	0.3%
0.505	53	0.3%
0.591	52	0.3%
0.962	51	0.3%
0.329	48	0.3%
0.493	46	0.2%
0.422	42	0.2%
0.319	42	0.2%
Other values (1236)	18316	97.2%

Value	Count	Frequency (%)
0	2	< 0.1%
0.023	1	< 0.1%
0.0243	1	< 0.1%
0.0277	1	< 0.1%
0.0292	2	< 0.1%
0.0301	1	< 0.1%
0.0309	1	< 0.1%
0.0312	1	< 0.1%
0.0316	1	< 0.1%
0.032	2	< 0.1%

Value	Count	Frequency (%)
0.984	1	< 0.1%
0.982	3	< 0.1%
0.981	2	< 0.1%
0.98	3	< 0.1%
0.979	2	< 0.1%
0.978	5	< 0.1%
0.977	4	< 0.1%
0.976	5	< 0.1%
0.975	6	< 0.1%
0.974	6	< 0.1%

	acousticness	audio_mode	audio_valence	danceability	energy	instrumentalness	key	liveness	loudness	song_duration_ms	song_popularity	speechiness	tempo	time_signature
acousticness	1.000	0.073	-0.040	-0.043	-0.591	-0.028	-0.001	-0.069	-0.454	-0.001	-0.037	-0.140	-0.167	0.121
audio_mode	0.073	1.000	0.024	0.112	0.069	0.017	0.277	0.027	0.059	0.019	0.036	0.114	0.023	0.022
audio_valence	-0.040	0.024	1.000	0.316	0.286	-0.132	0.024	-0.028	0.152	0.006	-0.050	0.042	0.025	0.079
danceability	-0.043	0.112	0.316	1.000	-0.035	-0.125	0.011	-0.107	0.085	0.003	0.101	0.288	-0.092	0.179
energy	-0.591	0.069	0.286	-0.035	1.000	-0.056	0.019	0.132	0.724	0.021	0.004	0.182	0.163	0.119
instrumentalness	-0.028	0.017	-0.132	-0.125	-0.056	1.000	-0.005	-0.047	-0.264	0.003	-0.201	-0.198	-0.004	0.054
key	-0.001	0.277	0.024	0.011	0.019	-0.005	1.000	-0.002	0.012	0.008	-0.015	0.048	0.004	0.016
liveness	-0.069	0.027	-0.028	-0.107	0.132	-0.047	-0.002	1.000	0.093	-0.005	-0.033	0.071	0.031	0.024
loudness	-0.454	0.059	0.152	0.085	0.724	-0.264	0.012	0.093	1.000	0.012	0.137	0.181	0.117	0.085
song_duration_ms	-0.001	0.019	0.006	0.003	0.021	0.003	0.008	-0.005	0.012	1.000	-0.013	0.001	0.007	0.021
song_popularity	-0.037	0.036	-0.050	0.101	0.004	-0.201	-0.015	-0.033	0.137	-0.013	1.000	0.040	-0.019	0.025
speechiness	-0.140	0.114	0.042	0.288	0.182	-0.198	0.048	0.071	0.181	0.001	0.040	1.000	0.078	0.062
tempo	-0.167	0.023	0.025	-0.092	0.163	-0.004	0.004	0.031	0.117	0.007	-0.019	0.078	1.000	0.413
time_signature	0.121	0.022	0.079	0.179	0.119	0.054	0.016	0.024	0.085	0.021	0.025	0.062	0.413	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	song_name	song_popularity	song_duration_ms	acousticness	danceability	energy	instrumentalness	key	liveness	loudness	audio_mode	speechiness	tempo	time_signature	audio_valence
0	Boulevard of Broken Dreams	73	189	0.005520	0.496	0.682	0.000029	8	0.0589	-4.095	1	0.0294	167.060	4	0.474
1	In The End	66	20325	0.010300	0.542	0.853	0.000000	3	0.1080	-6.407	0	0.0498	105.256	4	0.370
2	Seven Nation Army	76	-30411	0.008170	0.737	0.463	0.447000	0	0.2550	-7.828	1	0.0792	123.881	4	0.324
3	By The Way	74	20325	0.026400	0.451	0.970	0.003550	0	0.1020	-4.938	1	0.1070	122.444	4	0.198
4	How You Remind Me	56	27218	0.000954	0.447	0.766	0.000000	10	0.1130	-5.065	1	0.0313	172.011	4	0.574
5	Bring Me To Life	80	-26251	0.008950	0.316	0.945	0.000002	4	0.3960	-3.169	0	0.1240	189.931	4	0.320
6	Last Resort	81	3285	0.000504	0.581	0.887	0.001110	4	0.2680	-3.659	0	0.0624	90.578	4	0.724
7	Are You Gonna Be My Girl	76	17192	0.001480	0.613	0.953	0.000582	2	0.1520	-3.435	1	0.0855	105.046	4	0.537
8	Mr. Brightside	80	25978	0.001080	0.330	0.936	0.000000	1	0.0926	-3.660	1	0.0917	148.112	4	0.234
9	Sex on Fire	81	6738	0.001720	0.542	0.905	0.010400	9	0.1360	-5.653	1	0.0540	153.398	4	0.374

	song_name	song_popularity	song_duration_ms	acousticness	danceability	energy	instrumentalness	key	liveness	loudness	audio_mode	speechiness	tempo	time_signature	audio_valence
18825	Something Familiar	60	14394	0.906	0.491	0.0409	0.000015	0	0.0896	-18.431	1	0.0383	131.053	3	0.2780
18826	Call It Dreaming	67	-30384	0.610	0.519	0.5150	0.000057	5	0.1070	-9.448	1	0.0310	80.329	4	0.7140
18827	Stay Awake	55	-16490	0.898	0.370	0.1360	0.000263	7	0.0999	-13.528	1	0.0433	146.081	4	0.0592
18828	Build Me Up From Bones	64	19565	0.862	0.515	0.2860	0.000069	5	0.1060	-11.776	1	0.0378	115.076	4	0.2840
18829	I Know	62	-1502	0.395	0.644	0.5230	0.000000	4	0.0930	-7.660	1	0.0378	95.966	4	0.4450
18830	Let It Breathe	60	28573	0.893	0.500	0.1510	0.000065	11	0.1110	-16.107	1	0.0348	113.969	4	0.3000
18831	Answers	60	9058	0.765	0.495	0.1610	0.000001	11	0.1050	-14.078	0	0.0301	94.286	4	0.2650
18832	Sudden Love (Acoustic)	23	-14397	0.847	0.719	0.3250	0.000000	0	0.1250	-12.222	1	0.0355	130.534	4	0.2860
18833	Gentle on My Mind	55	24600	0.945	0.488	0.3260	0.015700	3	0.1190	-12.020	1	0.0328	106.063	4	0.3230
18834	Up to Me	60	-3075	0.911	0.640	0.3810	0.000254	4	0.1040	-11.790	1	0.0302	91.490	4	0.5810

Most frequently occurring

	song_name	song_popularity	song_duration_ms	acousticness	danceability	energy	instrumentalness	key	liveness	loudness	audio_mode	speechiness	tempo	time_signature	audio_valence	# duplicates
586	FEFE (feat. Nicki Minaj & Murda Beatz)	96	-17204	0.08800	0.931	0.387	0.000000	1	0.1360	-9.127	1	0.4120	125.978	4	0.376	19
1167	MIA (feat. Drake)	94	13759	0.01430	0.818	0.540	0.000512	6	0.0990	-6.350	0	0.0544	97.064	4	0.174	18
1811	Taki Taki (with Selena Gomez, Ozuna & Cardi B)	98	15892	0.15300	0.841	0.798	0.000003	1	0.0618	-4.206	0	0.2290	95.948	4	0.591	18
1362	No Stylist	91	-4436	0.02150	0.765	0.704	0.000000	5	0.2270	-4.589	0	0.1270	147.055	4	0.498	17
561	Electricity (with Dua Lipa)	94	-23971	0.01040	0.588	0.670	0.000003	0	0.3380	-6.439	1	0.0473	118.159	4	0.505	16
864	I Love It (& Lil Pump)	99	-3126	0.01140	0.901	0.522	0.000000	2	0.2590	-8.304	1	0.3300	104.053	4	0.329	16
1481	Promises (with Sam Smith)	98	16701	0.01190	0.781	0.768	0.000005	11	0.3250	-5.991	1	0.0394	123.070	4	0.486	16
1773	Sunflower - Spider-Man: Into the Spider-Verse	66	26981	0.54100	0.757	0.501	0.000000	2	0.0718	-5.593	1	0.0466	89.931	4	0.910	16
196	Be Alright	96	-235	0.69700	0.553	0.586	0.000000	11	0.0813	-6.319	1	0.0362	126.684	4	0.443	14
2038	Wake Up in the Sky	92	8056	0.00381	0.800	0.578	0.000000	4	0.3590	-5.144	0	0.0485	143.010	4	0.367	14

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring